/*
 * Copyright 2021 Shulie Technology, Co.Ltd
 * Email: shulie@shulie.io
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package io.shulie.tro.web.data.mapper.mysql;

import java.util.List;

import io.shulie.tro.web.data.model.mysql.PerformanceThreadDataEntity;
import io.shulie.tro.web.data.result.perfomanceanaly.PerformanceThreadCountResult;
import org.apache.ibatis.annotations.Select;

/**
 * @ClassName PerformanceThreadDataMapper
 * @Description
 * @Author qianshui
 * @Date 2020/11/4 下午2:21
 */
public interface PerformanceThreadDataMapper extends MyBatisPlusMapper<PerformanceThreadDataEntity> {

    @Select("SELECT base_id, count(id) as threadCount " +
        "from t_performance_thread_data " +
        "where base_id in " +
        "<foreach item=\'item\' index=\'index\' collection=\'list\' open=\'(\' separator=\',\' close=\')\'>" +
        "#{item}" +
        "</foreach>"
        + " group by base_id")
    List<PerformanceThreadCountResult> selectPerformanceThreadCount(List<Long> baseIds);
}
